Overview

Brought to you by YData

Dataset statistics

Number of variables	25
Number of observations	97057
Missing cells	99657
Missing cells (%)	4.1%
Duplicate rows	37
Duplicate rows (%)	< 0.1%
Total size in memory	87.5 MiB
Average record size in memory	945.4 B

Variable types

Numeric	10
DateTime	1
Text	8
Categorical	2
Unsupported	4

Alerts

Dataset has 37 (< 0.1%) duplicate rows	Duplicates
`4Digit` is highly overall correlated with `HSCode`	High correlation
`FOB INR` is highly overall correlated with `Item_No` and 2 other fields	High correlation
`HSCode` is highly overall correlated with `4Digit`	High correlation
`Item_No` is highly overall correlated with `FOB INR` and 1 other fields	High correlation
`Item_Rate_INR` is highly overall correlated with `Item_Rate_INV`	High correlation
`Item_Rate_INV` is highly overall correlated with `Item_Rate_INR`	High correlation
`Quantity` is highly overall correlated with `FOB INR` and 1 other fields	High correlation
`Total_Amount_INV_FC` is highly overall correlated with `FOB INR` and 2 other fields	High correlation
`Currency` is highly imbalanced (73.5%)	Imbalance
`Address2` has 97057 (100.0%) missing values	Missing
`IEC_PIN` has 2341 (2.4%) missing values	Missing
`Quantity` is highly skewed (γ1 = 47.67407942)	Skewed
`Item_Rate_INV` is highly skewed (γ1 = 84.21398735)	Skewed
`Total_Amount_INV_FC` is highly skewed (γ1 = 119.3453919)	Skewed
`FOB INR` is highly skewed (γ1 = 32.40570545)	Skewed
`Item_Rate_INR` is highly skewed (γ1 = 99.11496921)	Skewed
`Address2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ForeignCompany` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Invoice_No` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`IEC_PIN` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`FOB INR` has 9837 (10.1%) zeros	Zeros
`Item_Rate_INR` has 11676 (12.0%) zeros	Zeros

Reproduction

Analysis started	2025-03-28 10:00:04.810456
Analysis finished	2025-03-28 10:00:20.567959
Duration	15.76 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

BillNO
Real number (ℝ)

Distinct	39998
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8241919.8

Minimum	5876961
Maximum	8603453
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	5876961
5-th percentile	8012610
Q1	8143522
median	8297840
Q3	8461046
95-th percentile	8578895
Maximum	8603453
Range	2726492
Interquartile range (IQR)	317524

Descriptive statistics

Standard deviation	419787.36
Coefficient of variation (CV)	0.050933201
Kurtosis	18.207012
Mean	8241919.8
Median Absolute Deviation (MAD)	156968
Skewness	-4.0240342
Sum	7.9993601 × 10¹¹
Variance	1.7622143 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8198408	220	0.2%
6006245	219	0.2%
6002828	213	0.2%
6064288	213	0.2%
8255517	212	0.2%
8285915	189	0.2%
8148377	161	0.2%
8028523	156	0.2%
8142695	154	0.2%
8275468	146	0.2%
Other values (39988)	95174	98.1%

Value	Count	Frequency (%)
5876961	1	< 0.1%
5882473	1	< 0.1%
5885189	2	< 0.1%
5885228	1	< 0.1%
5889366	4	< 0.1%
5890450	2	< 0.1%
5892079	12	< 0.1%
5892155	1	< 0.1%
5895260	1	< 0.1%
5896224	1	< 0.1%

Value	Count	Frequency (%)
8603453	1	< 0.1%
8603452	5	< 0.1%
8603451	1	< 0.1%
8603450	1	< 0.1%
8603449	1	< 0.1%
8603447	1	< 0.1%
8603446	1	< 0.1%
8603443	1	< 0.1%
8603437	1	< 0.1%
8603434	1	< 0.1%

4Digit
Real number (ℝ)

High correlation

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2980.1134

Minimum	2901
Maximum	3006
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	2901
5-th percentile	2914
Q1	2941
median	3004
Q3	3004
95-th percentile	3004
Maximum	3006
Range	105
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	36.27966
Coefficient of variation (CV)	0.012173919
Kurtosis	-0.95351131
Mean	2980.1134
Median Absolute Deviation (MAD)	0
Skewness	-0.93888877
Sum	2.8924087 × 10⁸
Variance	1316.2137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
3004	57904	59.7%
2933	5439	5.6%
2942	4505	4.6%
3003	4477	4.6%
3005	1697	1.7%
2915	1649	1.7%
3006	1537	1.6%
2941	1530	1.6%
2922	1398	1.4%
3002	1363	1.4%
Other values (39)	15558	16.0%

Value	Count	Frequency (%)
2901	32	< 0.1%
2902	325	0.3%
2903	484	0.5%
2904	349	0.4%
2905	833	0.9%
2906	508	0.5%
2907	450	0.5%
2908	99	0.1%
2909	700	0.7%
2910	57	0.1%

Value	Count	Frequency (%)
3006	1537	1.6%
3005	1697	1.7%
3004	57904	59.7%
3003	4477	4.6%
3002	1363	1.4%
3001	77	0.1%
3000	2	< 0.1%
2942	4505	4.6%
2941	1530	1.6%
2940	127	0.1%

Date
Date

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	758.4 KiB

Minimum	2016-06-01 00:00:00
Maximum	2016-06-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=30)

HSCode
Real number (ℝ)

High correlation

Distinct	762
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29807567

Minimum	29011000
Maximum	30069200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	29011000
5-th percentile	29147090
Q1	29411090
median	30049011
Q3	30049099
95-th percentile	30049099
Maximum	30069200
Range	1058200
Interquartile range (IQR)	638009

Descriptive statistics

Standard deviation	364328.76
Coefficient of variation (CV)	0.012222694
Kurtosis	-0.95710324
Mean	29807567
Median Absolute Deviation (MAD)	4921
Skewness	-0.937508
Sum	2.893033 × 10¹²
Variance	1.3273545 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30049099	28274	29.1%
30049011	4197	4.3%
29420090	3958	4.1%
30033900	2326	2.4%
30049079	1847	1.9%
30041090	1764	1.8%
30042099	1726	1.8%
29339900	1554	1.6%
30049069	1442	1.5%
30045090	1405	1.4%
Other values (752)	48564	50.0%

Value	Count	Frequency (%)
29011000	13	< 0.1%
29012400	4	< 0.1%
29012910	1	< 0.1%
29012990	14	< 0.1%
29021100	5	< 0.1%
29021900	41	< 0.1%
29022000	5	< 0.1%
29023000	14	< 0.1%
29024100	6	< 0.1%
29024300	1	< 0.1%

Value	Count	Frequency (%)
30069200	9	< 0.1%
30069100	4	< 0.1%
30067000	94	0.1%
30066030	8	< 0.1%
30066020	88	0.1%
30066010	192	0.2%
30065000	61	0.1%
30064000	503	0.5%
30063000	74	0.1%
30062000	10	< 0.1%

Product
Text

Distinct	61992
Distinct (%)	63.9%
Missing	0
Missing (%)	0.0%
Memory size	10.1 MiB

Length

Max length	120
Median length	88
Mean length	59.624118
Min length	3

Characters and Unicode

Total characters	5786938
Distinct characters	91
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	45907 ?
Unique (%)	47.3%

Sample

1st row	ETHYLENE GLYCOL DISTERATE (Assay 98% minimum) (EGDS)
2nd row	COSMOSIL IM
3rd row	MEBEVERINE HCL BP
4th row	WE INTEND TO CLAIM REWARDS UNDER MERCHANDISE EXPORTS FROM INDIA SCHEME (MEIS)
5th row	"Payflex-M-80" Di Octyl Maleate Ester, C

Value	Count	Frequency (%)
	28363	3.7%
tablets	12895	1.7%
to	9398	1.2%
mg	8157	1.1%
of	7483	1.0%
usp	7248	0.9%
meis	6240	0.8%
no	6155	0.8%
under	6034	0.8%
claim	5641	0.7%
Other values (72983)	676256	87.4%

Most occurring characters

Value	Count	Frequency (%)
	700082	12.1%
E	401954	6.9%
A	365063	6.3%
I	306647	5.3%
T	278286	4.8%
O	255433	4.4%
N	238778	4.1%
R	236235	4.1%
S	228937	4.0%
L	220164	3.8%
Other values (81)	2555359	44.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3975724	68.7%
Space Separator	700082	12.1%
Decimal Number	537085	9.3%
Lowercase Letter	207789	3.6%
Other Punctuation	160006	2.8%
Open Punctuation	76984	1.3%
Close Punctuation	68650	1.2%
Dash Punctuation	53840	0.9%
Math Symbol	6243	0.1%
Modifier Symbol	204	< 0.1%
Other values (2)	331	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	401954	10.1%
A	365063	9.2%
I	306647	7.7%
T	278286	7.0%
O	255433	6.4%
N	238778	6.0%
R	236235	5.9%
S	228937	5.8%
L	220164	5.5%
M	217862	5.5%
Other values (16)	1226365	30.8%

Lowercase Letter

Value	Count	Frequency (%)
e	22611	10.9%
a	18414	8.9%
i	17670	8.5%
n	15214	7.3%
o	15050	7.2%
t	14304	6.9%
r	13867	6.7%
l	11656	5.6%
s	9632	4.6%
d	9104	4.4%
Other values (16)	60267	29.0%

Other Punctuation

Value	Count	Frequency (%)
.	59507	37.2%
:	25922	16.2%
/	25056	15.7%
,	23854	14.9%
'	8658	5.4%
%	5893	3.7%
&	5588	3.5%
"	2889	1.8%
#	1114	0.7%
;	716	0.4%
Other values (3)	809	0.5%

Decimal Number

Value	Count	Frequency (%)
0	172049	32.0%
1	103857	19.3%
2	60867	11.3%
5	54322	10.1%
3	34341	6.4%
6	31282	5.8%
4	26592	5.0%
9	19955	3.7%
8	17158	3.2%
7	16662	3.1%

Math Symbol

Value	Count	Frequency (%)
+	3326	53.3%
=	2888	46.3%
>	27	0.4%
<	2	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	71804	93.3%
[	5060	6.6%
{	120	0.2%

Close Punctuation

Value	Count	Frequency (%)
)	63945	93.1%
]	4604	6.7%
}	101	0.1%

Modifier Symbol

Value	Count	Frequency (%)
`	197	96.6%
^	7	3.4%

Space Separator

Value	Count	Frequency (%)
	700082	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	53840	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	167	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	164	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4183513	72.3%
Common	1603425	27.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	401954	9.6%
A	365063	8.7%
I	306647	7.3%
T	278286	6.7%
O	255433	6.1%
N	238778	5.7%
R	236235	5.6%
S	228937	5.5%
L	220164	5.3%
M	217862	5.2%
Other values (42)	1434154	34.3%

Common

Value	Count	Frequency (%)
	700082	43.7%
0	172049	10.7%
1	103857	6.5%
(	71804	4.5%
)	63945	4.0%
2	60867	3.8%
.	59507	3.7%
5	54322	3.4%
-	53840	3.4%
3	34341	2.1%
Other values (29)	228811	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5786938	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	700082	12.1%
E	401954	6.9%
A	365063	6.3%
I	306647	5.3%
T	278286	4.8%
O	255433	4.4%
N	238778	4.1%
R	236235	4.1%
S	228937	4.0%
L	220164	3.8%
Other values (81)	2555359	44.2%

Quantity
Real number (ℝ)

High correlation Skewed

Distinct	15078
Distinct (%)	15.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41652.891

Minimum	0.001
Maximum	53019608
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	0.001
5-th percentile	1
Q1	15
median	264
Q3	4315
95-th percentile	59670.8
Maximum	53019608
Range	53019608
Interquartile range (IQR)	4300

Descriptive statistics

Standard deviation	532786.57
Coefficient of variation (CV)	12.791107
Kurtosis	3422.5653
Mean	41652.891
Median Absolute Deviation (MAD)	263
Skewness	47.674079
Sum	4.0427046 × 10⁹
Variance	2.8386153 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	7722	8.0%
100	2902	3.0%
50	2323	2.4%
10	2312	2.4%
200	1851	1.9%
20	1824	1.9%
1000	1767	1.8%
5	1703	1.8%
2	1632	1.7%
500	1579	1.6%
Other values (15068)	71442	73.6%

Value	Count	Frequency (%)
0.001	1406	1.4%
0.002	27	< 0.1%
0.003	12	< 0.1%
0.004	14	< 0.1%
0.005	73	0.1%
0.006	7	< 0.1%
0.007	11	< 0.1%
0.008	9	< 0.1%
0.009	4	< 0.1%
0.01	965	1.0%

Value	Count	Frequency (%)
53019608	1	< 0.1%
50980392	1	< 0.1%
43779000	1	< 0.1%
42000000	1	< 0.1%
35280000	1	< 0.1%
29505000	1	< 0.1%
25000000	1	< 0.1%
24750000	1	< 0.1%
22522000	1	< 0.1%
21358080	1	< 0.1%

Unit
Categorical

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

NOS	26950
PAC	23327
KGS	23222
PCS	6011
MTS	2976
Other values (32)	14571

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	291171
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	KGS
2nd row	KGS
3rd row	KGS
4th row	NOS
5th row	KGS

Common Values

Value	Count	Frequency (%)
NOS	26950	27.8%
PAC	23327	24.0%
KGS	23222	23.9%
PCS	6011	6.2%
MTS	2976	3.1%
BOX	2742	2.8%
VLS	2401	2.5%
GMS	2391	2.5%
LOT	2239	2.3%
BTL	1710	1.8%
Other values (27)	3088	3.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nos	26950	27.8%
pac	23327	24.0%
kgs	23222	23.9%
pcs	6011	6.2%
mts	2976	3.1%
box	2742	2.8%
vls	2401	2.5%
gms	2391	2.5%
lot	2239	2.3%
btl	1710	1.8%
Other values (27)	3088	3.2%

Most occurring characters

Value	Count	Frequency (%)
S	64661	22.2%
O	32258	11.1%
C	30679	10.5%
P	29352	10.1%
N	28283	9.7%
G	25675	8.8%
A	23376	8.0%
K	23243	8.0%
T	9553	3.3%
L	6718	2.3%
Other values (11)	17373	6.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	291171	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	64661	22.2%
O	32258	11.1%
C	30679	10.5%
P	29352	10.1%
N	28283	9.7%
G	25675	8.8%
A	23376	8.0%
K	23243	8.0%
T	9553	3.3%
L	6718	2.3%
Other values (11)	17373	6.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	291171	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	64661	22.2%
O	32258	11.1%
C	30679	10.5%
P	29352	10.1%
N	28283	9.7%
G	25675	8.8%
A	23376	8.0%
K	23243	8.0%
T	9553	3.3%
L	6718	2.3%
Other values (11)	17373	6.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	291171	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	64661	22.2%
O	32258	11.1%
C	30679	10.5%
P	29352	10.1%
N	28283	9.7%
G	25675	8.8%
A	23376	8.0%
K	23243	8.0%
T	9553	3.3%
L	6718	2.3%
Other values (11)	17373	6.0%

Item_Rate_INV
Real number (ℝ)

High correlation Skewed

Distinct	13015
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2117.2733

Minimum	0
Maximum	10346959
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.001
Q1	0.8
median	4.45
Q3	43.9
95-th percentile	1347.7217
Maximum	10346959
Range	10346959
Interquartile range (IQR)	43.1

Descriptive statistics

Standard deviation	74306.097
Coefficient of variation (CV)	35.095184
Kurtosis	8750.7367
Mean	2117.2733
Median Absolute Deviation (MAD)	4.4
Skewness	84.213987
Sum	2.054962 × 10⁸
Variance	5.521396 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.001	2826	2.9%
0.0001	1686	1.7%
1 × 10^-5	1564	1.6%
1	1250	1.3%
2	870	0.9%
0.01	833	0.9%
0.5	657	0.7%
10	566	0.6%
5	512	0.5%
1.5	504	0.5%
Other values (13005)	85789	88.4%

Value	Count	Frequency (%)
0	3	< 0.1%
1 × 10^-5	1564	1.6%
2 × 10^-5	13	< 0.1%
3 × 10^-5	13	< 0.1%
4 × 10^-5	6	< 0.1%
5 × 10^-5	8	< 0.1%
6 × 10^-5	1	< 0.1%
8 × 10^-5	1	< 0.1%
9 × 10^-5	7	< 0.1%
0.0001	1686	1.7%

Value	Count	Frequency (%)
10346959	1	< 0.1%
9044224	1	< 0.1%
6685303.67	2	< 0.1%
5277000	1	< 0.1%
5219000	2	< 0.1%
3493063	8	< 0.1%
2992500	1	< 0.1%
2818550	1	< 0.1%
2726000	2	< 0.1%
2291941	1	< 0.1%

Currency
Categorical

Imbalance

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

USD	77035
INR	8514
EUR	8256
GBP	1472
AUD	605
Other values (14)	1175

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	291171
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	USD
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	77035	79.4%
INR	8514	8.8%
EUR	8256	8.5%
GBP	1472	1.5%
AUD	605	0.6%
CAD	270	0.3%
SGD	217	0.2%
ZAR	205	0.2%
RUR	203	0.2%
NZD	84	0.1%
Other values (9)	196	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
usd	77035	79.4%
inr	8514	8.8%
eur	8256	8.5%
gbp	1472	1.5%
aud	605	0.6%
cad	270	0.3%
sgd	217	0.2%
zar	205	0.2%
rur	203	0.2%
nzd	84	0.1%
Other values (9)	196	0.2%

Most occurring characters

Value	Count	Frequency (%)
U	86154	29.6%
D	78261	26.9%
S	77252	26.5%
R	17436	6.0%
N	8648	3.0%
I	8514	2.9%
E	8304	2.9%
G	1689	0.6%
B	1527	0.5%
P	1506	0.5%
Other values (11)	1880	0.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	291171	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	86154	29.6%
D	78261	26.9%
S	77252	26.5%
R	17436	6.0%
N	8648	3.0%
I	8514	2.9%
E	8304	2.9%
G	1689	0.6%
B	1527	0.5%
P	1506	0.5%
Other values (11)	1880	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	291171	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	86154	29.6%
D	78261	26.9%
S	77252	26.5%
R	17436	6.0%
N	8648	3.0%
I	8514	2.9%
E	8304	2.9%
G	1689	0.6%
B	1527	0.5%
P	1506	0.5%
Other values (11)	1880	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	291171	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	86154	29.6%
D	78261	26.9%
S	77252	26.5%
R	17436	6.0%
N	8648	3.0%
I	8514	2.9%
E	8304	2.9%
G	1689	0.6%
B	1527	0.5%
P	1506	0.5%
Other values (11)	1880	0.6%

Total_Amount_INV_FC
Real number (ℝ)

High correlation Skewed

Distinct	37378
Distinct (%)	38.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1028928.6

Minimum	0
Maximum	7.7989376 × 10⁹
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.001
Q1	122.05
median	3346.56
Q3	23760
95-th percentile	231000
Maximum	7.7989376 × 10⁹
Range	7.7989376 × 10⁹
Interquartile range (IQR)	23637.95

Descriptive statistics

Standard deviation	48083693
Coefficient of variation (CV)	46.731807
Kurtosis	16604.368
Mean	1028928.6
Median Absolute Deviation (MAD)	3345.56
Skewness	119.34539
Sum	9.9864725 × 10¹⁰
Variance	2.3120415 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0001	1431	1.5%
0.001	1351	1.4%
1 × 10^-6	983	1.0%
1 × 10^-5	940	1.0%
2	475	0.5%
1	397	0.4%
0.01	360	0.4%
10	352	0.4%
5	316	0.3%
3000	267	0.3%
Other values (37368)	90185	92.9%

Value	Count	Frequency (%)
0	3	< 0.1%
1 × 10^-8	180	0.2%
5 × 10^-8	3	< 0.1%
9 × 10^-8	1	< 0.1%
1 × 10^-7	256	0.3%
2 × 10^-7	1	< 0.1%
3 × 10^-7	1	< 0.1%
5 × 10^-7	18	< 0.1%
6 × 10^-7	1	< 0.1%
9 × 10^-7	1	< 0.1%

Value	Count	Frequency (%)
7798937590	1	< 0.1%
7749174697	1	< 0.1%
4258940906	2	< 0.1%
4044600000	1	< 0.1%
3394899200	2	< 0.1%
3007872900	1	< 0.1%
2374233260	1	< 0.1%
1636760000	1	< 0.1%
1186876250	1	< 0.1%
688517560	1	< 0.1%

FOB INR
Real number (ℝ)

High correlation Skewed Zeros

Distinct	63342
Distinct (%)	65.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1329140.6

Minimum	-2348.4
Maximum	6.4153726 × 10⁸
Zeros	9837
Zeros (%)	10.1%
Negative	6
Negative (%)	< 0.1%
Memory size	758.4 KiB

Quantile statistics

Minimum	-2348.4
5-th percentile	0
Q1	3596.4
median	109557.11
Q3	904453.6
95-th percentile	5490232.3
Maximum	6.4153726 × 10⁸
Range	6.4153961 × 10⁸
Interquartile range (IQR)	900857.2

Descriptive statistics

Standard deviation	6353195.3
Coefficient of variation (CV)	4.7799273
Kurtosis	1930.8777
Mean	1329140.6
Median Absolute Deviation (MAD)	109557.11
Skewness	32.405705
Sum	1.290024 × 10¹¹
Variance	4.036309 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9837	10.1%
1000	985	1.0%
2000	599	0.6%
3000	375	0.4%
4000	266	0.3%
132.7	221	0.2%
5000	210	0.2%
6000	189	0.2%
66.35	188	0.2%
66.6	164	0.2%
Other values (63332)	84023	86.6%

Value	Count	Frequency (%)
-2348.4	1	< 0.1%
-778.18	1	< 0.1%
-389.09	1	< 0.1%
-194.54	3	< 0.1%
0	9837	10.1%
0.01	19	< 0.1%
0.02	13	< 0.1%
0.03	3	< 0.1%
0.04	5	< 0.1%
0.05	2	< 0.1%

Value	Count	Frequency (%)
641537264	1	< 0.1%
446293100	1	< 0.1%
339372288	1	< 0.1%
318622539	1	< 0.1%
317609752	1	< 0.1%
284692804	1	< 0.1%
277308334	1	< 0.1%
253406250	1	< 0.1%
248863150	1	< 0.1%
235527973	1	< 0.1%

ForeignPort
Text

Distinct	1165
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	5.3 MiB

Length

Max length	34
Median length	20
Mean length	8.4687555
Min length	3

Characters and Unicode

Total characters	821952
Distinct characters	62
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	186 ?
Unique (%)	0.2%

Sample

1st row	Chittagong
2nd row	Colombo
3rd row	Riyadh
4th row	Veracruz
5th row	Jeddah

Value	Count	Frequency (%)
singapore	3705	2.9%
london	3689	2.9%
birgunj	3080	2.4%
new	2859	2.3%
york	2843	2.3%
	2780	2.2%
colombo	2438	1.9%
kathmandu	2088	1.7%
heathrow	2026	1.6%
island	1742	1.4%
Other values (1056)	98934	78.4%

Most occurring characters

Value	Count	Frequency (%)
a	93034	11.3%
o	53113	6.5%
n	48985	6.0%
e	41139	5.0%
r	40544	4.9%
i	38236	4.7%
	29642	3.6%
t	27404	3.3%
u	27012	3.3%
l	26482	3.2%
Other values (52)	396361	48.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	556395	67.7%
Uppercase Letter	228909	27.8%
Space Separator	29642	3.6%
Dash Punctuation	2728	0.3%
Other Punctuation	1901	0.2%
Open Punctuation	1324	0.2%
Close Punctuation	972	0.1%
Math Symbol	81	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	93034	16.7%
o	53113	9.5%
n	48985	8.8%
e	41139	7.4%
r	40544	7.3%
i	38236	6.9%
t	27404	4.9%
u	27012	4.9%
l	26482	4.8%
g	21228	3.8%
Other values (16)	139218	25.0%

Uppercase Letter

Value	Count	Frequency (%)
O	17953	7.8%
A	17735	7.7%
N	17451	7.6%
M	16249	7.1%
S	15509	6.8%
L	13342	5.8%
H	12086	5.3%
C	11487	5.0%
E	11486	5.0%
K	11237	4.9%
Other values (16)	84374	36.9%

Other Punctuation

Value	Count	Frequency (%)
/	747	39.3%
,	524	27.6%
'	372	19.6%
.	130	6.8%
?	128	6.7%

Space Separator

Value	Count	Frequency (%)
	29642	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2728	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1324	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	972	100.0%

Math Symbol

Value	Count	Frequency (%)
=	81	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	785304	95.5%
Common	36648	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	93034	11.8%
o	53113	6.8%
n	48985	6.2%
e	41139	5.2%
r	40544	5.2%
i	38236	4.9%
t	27404	3.5%
u	27012	3.4%
l	26482	3.4%
g	21228	2.7%
Other values (42)	368127	46.9%

Common

Value	Count	Frequency (%)
	29642	80.9%
-	2728	7.4%
(	1324	3.6%
)	972	2.7%
/	747	2.0%
,	524	1.4%
'	372	1.0%
.	130	0.4%
?	128	0.3%
=	81	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	821952	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	93034	11.3%
o	53113	6.5%
n	48985	6.0%
e	41139	5.0%
r	40544	4.9%
i	38236	4.7%
	29642	3.6%
t	27404	3.3%
u	27012	3.3%
l	26482	3.2%
Other values (52)	396361	48.2%

ForeignCountry
Text

Distinct	212
Distinct (%)	0.2%
Missing	230
Missing (%)	0.2%
Memory size	5.4 MiB

Length

Max length	41
Median length	27
Mean length	9.2091875
Min length	4

Characters and Unicode

Total characters	891698
Distinct characters	50
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	BANGLADESH
2nd row	SRI LANKA
3rd row	SAUDI ARABIA
4th row	MEXICO
5th row	SAUDI ARABIA

Value	Count	Frequency (%)
united	16199	12.4%
states	9852	7.5%
nepal	5203	4.0%
kingdom	4693	3.6%
singapore	3706	2.8%
germany	2615	2.0%
sri	2438	1.9%
lanka	2438	1.9%
kenya	2275	1.7%
of	2273	1.7%
Other values (224)	79228	60.5%

Most occurring characters

Value	Count	Frequency (%)
A	123203	13.8%
E	84398	9.5%
N	83433	9.4%
I	78816	8.8%
T	61000	6.8%
S	55251	6.2%
R	42997	4.8%
D	38542	4.3%
U	35217	3.9%
L	35080	3.9%
Other values (40)	253761	28.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	841990	94.4%
Space Separator	34093	3.8%
Lowercase Letter	13365	1.5%
Other Punctuation	2180	0.2%
Dash Punctuation	70	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	123203	14.6%
E	84398	10.0%
N	83433	9.9%
I	78816	9.4%
T	61000	7.2%
S	55251	6.6%
R	42997	5.1%
D	38542	4.6%
U	35217	4.2%
L	35080	4.2%
Other values (16)	204053	24.2%

Lowercase Letter

Value	Count	Frequency (%)
o	1908	14.3%
c	1908	14.3%
i	1361	10.2%
e	1272	9.5%
a	813	6.1%
t	730	5.5%
n	724	5.4%
p	642	4.8%
g	642	4.8%
r	637	4.8%
Other values (8)	2728	20.4%

Other Punctuation

Value	Count	Frequency (%)
.	1122	51.5%
,	1004	46.1%
'	51	2.3%
&	3	0.1%

Space Separator

Value	Count	Frequency (%)
	34093	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	70	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	855355	95.9%
Common	36343	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	123203	14.4%
E	84398	9.9%
N	83433	9.8%
I	78816	9.2%
T	61000	7.1%
S	55251	6.5%
R	42997	5.0%
D	38542	4.5%
U	35217	4.1%
L	35080	4.1%
Other values (34)	217418	25.4%

Common

Value	Count	Frequency (%)
	34093	93.8%
.	1122	3.1%
,	1004	2.8%
-	70	0.2%
'	51	0.1%
&	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	891698	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	123203	13.8%
E	84398	9.5%
N	83433	9.4%
I	78816	8.8%
T	61000	6.8%
S	55251	6.2%
R	42997	4.8%
D	38542	4.3%
U	35217	3.9%
L	35080	3.9%
Other values (40)	253761	28.5%

IndianPort
Text

Distinct	65
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.9 MiB

Length

Max length	48
Median length	29
Mean length	15.10229
Min length	6

Characters and Unicode

Total characters	1465783
Distinct characters	52
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Nhava Sheva Sea
2nd row	Nhava Sheva Sea
3rd row	Hyderabad Air Cargo
4th row	Nhava Sheva Sea
5th row	Hazira

Value	Count	Frequency (%)
air	52963	19.9%
cargo	52963	19.9%
sea	31590	11.9%
bombay	27436	10.3%
nhava	25697	9.6%
sheva	25697	9.6%
hyderabad	8205	3.1%
delhi	8104	3.0%
chennai	6417	2.4%
raxaul	4712	1.8%
Other values (69)	22692	8.5%

Most occurring characters

Value	Count	Frequency (%)
a	246623	16.8%
	171132	11.7%
r	128075	8.7%
o	89762	6.1%
e	88882	6.1%
i	74400	5.1%
h	71353	4.9%
C	63882	4.4%
S	58836	4.0%
A	58263	4.0%
Other values (42)	414575	28.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1005749	68.6%
Uppercase Letter	286248	19.5%
Space Separator	171132	11.7%
Other Punctuation	1086	0.1%
Dash Punctuation	906	0.1%
Open Punctuation	331	< 0.1%
Close Punctuation	331	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	246623	24.5%
r	128075	12.7%
o	89762	8.9%
e	88882	8.8%
i	74400	7.4%
h	71353	7.1%
g	58116	5.8%
v	51632	5.1%
b	40779	4.1%
y	36100	3.6%
Other values (14)	120027	11.9%

Uppercase Letter

Value	Count	Frequency (%)
C	63882	22.3%
S	58836	20.6%
A	58263	20.4%
B	32130	11.2%
N	26766	9.4%
D	11685	4.1%
H	9550	3.3%
R	6004	2.1%
I	4514	1.6%
T	2905	1.0%
Other values (12)	11713	4.1%

Other Punctuation

Value	Count	Frequency (%)
,	630	58.0%
/	456	42.0%

Space Separator

Value	Count	Frequency (%)
	171132	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	906	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	331	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	331	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1291997	88.1%
Common	173786	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	246623	19.1%
r	128075	9.9%
o	89762	6.9%
e	88882	6.9%
i	74400	5.8%
h	71353	5.5%
C	63882	4.9%
S	58836	4.6%
A	58263	4.5%
g	58116	4.5%
Other values (36)	353805	27.4%

Common

Value	Count	Frequency (%)
	171132	98.5%
-	906	0.5%
,	630	0.4%
/	456	0.3%
(	331	0.2%
)	331	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1465783	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	246623	16.8%
	171132	11.7%
r	128075	8.7%
o	89762	6.1%
e	88882	6.1%
i	74400	5.1%
h	71353	4.9%
C	63882	4.4%
S	58836	4.0%
A	58263	4.0%
Other values (42)	414575	28.3%

IEC
Real number (ℝ)

Distinct	3129
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.8689572 × 10⁸

Minimum	1.0000001 × 10⁸
Maximum	6.111002 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	1.0000001 × 10⁸
5-th percentile	3.0402392 × 10⁸
Q1	3.8806326 × 10⁸
median	3.9903396 × 10⁸
Q3	8.9600434 × 10⁸
95-th percentile	3.4080061 × 10⁹
Maximum	6.111002 × 10⁹
Range	6.011002 × 10⁹
Interquartile range (IQR)	5.0794108 × 10⁸

Descriptive statistics

Standard deviation	9.8226923 × 10⁸
Coefficient of variation (CV)	1.1075363
Kurtosis	4.6320903
Mean	8.8689572 × 10⁸
Median Absolute Deviation (MAD)	95013121
Skewness	2.3165339
Sum	8.6079438 × 10¹³
Variance	9.6485284 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
388003791	2271	2.3%
509001220	1985	2.0%
388014482	1872	1.9%
2588000011	1592	1.6%
896004341	1465	1.5%
388026448	1428	1.5%
988002833	1283	1.3%
392072823	1242	1.3%
788012363	997	1.0%
895001721	973	1.0%
Other values (3119)	81949	84.4%

Value	Count	Frequency (%)
100000011	141	0.1%
100000053	31	< 0.1%
100000061	9	< 0.1%
200000829	2	< 0.1%
200016601	1	< 0.1%
201004151	1	< 0.1%
201009404	3	< 0.1%
201011972	14	< 0.1%
202002080	3	< 0.1%
202018962	3	< 0.1%

Value	Count	Frequency (%)
6111002040	1	< 0.1%
6107001085	2	< 0.1%
6107000526	1	< 0.1%
5613004307	3	< 0.1%
5311000929	14	< 0.1%
5299004184	9	< 0.1%
5297004136	4	< 0.1%
5297000033	14	< 0.1%
5296000404	2	< 0.1%
5295000036	7	< 0.1%

IndianCompany
Text

Distinct	3170
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Memory size	6.8 MiB

Length

Max length	50
Median length	41
Mean length	24.746984
Min length	3

Characters and Unicode

Total characters	2401868
Distinct characters	46
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	600 ?
Unique (%)	0.6%

Sample

1st row	GALAXY SURFACTANTS LTD.,
2nd row	DADIA CHEMICAL INDUSTRIES
3rd row	RA CHEM PHARMA LIMITED
4th row	CHEMSPEC CHEMICALS PVT LTD
5th row	PAYAL PETROCHEM PRIVATE LIMITED

Value	Count	Frequency (%)
ltd	37924	11.6%
limited	29003	8.9%
pvt	15808	4.9%
pharmaceuticals	12147	3.7%
laboratories	10062	3.1%
pharma	9321	2.9%
private	8746	2.7%
india	6289	1.9%
	5807	1.8%
pvt.ltd	5456	1.7%
Other values (3434)	185000	56.8%

Most occurring characters

Value	Count	Frequency (%)
	238038	9.9%
A	232021	9.7%
I	207915	8.7%
T	192539	8.0%
E	191237	8.0%
L	164988	6.9%
R	142151	5.9%
D	118266	4.9%
S	115015	4.8%
M	100862	4.2%
Other values (36)	698836	29.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2076775	86.5%
Space Separator	238038	9.9%
Other Punctuation	78719	3.3%
Open Punctuation	3149	0.1%
Close Punctuation	3083	0.1%
Dash Punctuation	1804	0.1%
Decimal Number	234	< 0.1%
Modifier Symbol	66	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	232021	11.2%
I	207915	10.0%
T	192539	9.3%
E	191237	9.2%
L	164988	7.9%
R	142151	6.8%
D	118266	5.7%
S	115015	5.5%
M	100862	4.9%
C	96731	4.7%
Other values (16)	515050	24.8%

Other Punctuation

Value	Count	Frequency (%)
.	56843	72.2%
,	16350	20.8%
&	5411	6.9%
%	44	0.1%
/	35	< 0.1%
;	31	< 0.1%
:	5	< 0.1%

Decimal Number

Value	Count	Frequency (%)
0	92	39.3%
1	66	28.2%
3	49	20.9%
2	25	10.7%
9	1	0.4%
4	1	0.4%

Open Punctuation

Value	Count	Frequency (%)
(	3143	99.8%
[	6	0.2%

Close Punctuation

Value	Count	Frequency (%)
)	3077	99.8%
]	6	0.2%

Space Separator

Value	Count	Frequency (%)
	238038	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1804	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	66	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2076775	86.5%
Common	325093	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	232021	11.2%
I	207915	10.0%
T	192539	9.3%
E	191237	9.2%
L	164988	7.9%
R	142151	6.8%
D	118266	5.7%
S	115015	5.5%
M	100862	4.9%
C	96731	4.7%
Other values (16)	515050	24.8%

Common

Value	Count	Frequency (%)
	238038	73.2%
.	56843	17.5%
,	16350	5.0%
&	5411	1.7%
(	3143	1.0%
)	3077	0.9%
-	1804	0.6%
0	92	< 0.1%
`	66	< 0.1%
1	66	< 0.1%
Other values (10)	203	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2401868	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	238038	9.9%
A	232021	9.7%
I	207915	8.7%
T	192539	8.0%
E	191237	8.0%
L	164988	6.9%
R	142151	5.9%
D	118266	4.9%
S	115015	4.8%
M	100862	4.2%
Other values (36)	698836	29.1%

Address1
Text

Distinct	3121
Distinct (%)	3.2%
Missing	9
Missing (%)	< 0.1%
Memory size	8.9 MiB

Length

Max length	102
Median length	79
Mean length	47.368014
Min length	7

Characters and Unicode

Total characters	4596971
Distinct characters	74
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	587 ?
Unique (%)	0.6%

Sample

1st row	C-49/2,TTC INDUSTRIAL AREAPAWNE, NAVI MUMBAI.
2nd row	201, SHIVAM , 3RD FLOOR, SATYAM SHOPPING CENTRE,M.G. ROAD
3rd row	#.6-3-1239/2, AMAR HOUSE, 4TH FLOORRAJBHAWAN ROAD, SOMAJIGUDA,
4th row	9 WALLACE ST FORT
5th row	E-24, NETAJI SUBHASH MARGDARYAGANJ

Value	Count	Frequency (%)
road	22440	3.9%
floor	10465	1.8%
	8869	1.5%
plot	8716	1.5%
no	6481	1.1%
marg	5305	0.9%
industrial	4948	0.9%
house	3972	0.7%
nagar	3778	0.7%
2nd	3674	0.6%
Other values (8556)	493846	86.3%

Most occurring characters

Value	Count	Frequency (%)
	503319	10.9%
A	489814	10.7%
R	292293	6.4%
,	267192	5.8%
O	242069	5.3%
E	237516	5.2%
N	221315	4.8%
I	214583	4.7%
T	182808	4.0%
L	170531	3.7%
Other values (64)	1775531	38.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3338670	72.6%
Space Separator	503319	10.9%
Other Punctuation	392263	8.5%
Decimal Number	285404	6.2%
Dash Punctuation	43158	0.9%
Open Punctuation	11984	0.3%
Close Punctuation	11581	0.3%
Lowercase Letter	10292	0.2%
Modifier Symbol	281	< 0.1%
Math Symbol	19	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	489814	14.7%
R	292293	8.8%
O	242069	7.3%
E	237516	7.1%
N	221315	6.6%
I	214583	6.4%
T	182808	5.5%
L	170531	5.1%
S	170365	5.1%
D	168891	5.1%
Other values (16)	948485	28.4%

Lowercase Letter

Value	Count	Frequency (%)
ß	1370	13.3%
e	1200	11.7%
t	1090	10.6%
n	998	9.7%
r	958	9.3%
o	796	7.7%
s	729	7.1%
i	667	6.5%
l	592	5.8%
m	331	3.2%
Other values (9)	1561	15.2%

Other Punctuation

Value	Count	Frequency (%)
,	267192	68.1%
.	96684	24.6%
/	22641	5.8%
&	3783	1.0%
:	1026	0.3%
*	407	0.1%
#	318	0.1%
;	134	< 0.1%
?	64	< 0.1%
"	14	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	65850	23.1%
2	49039	17.2%
3	34030	11.9%
0	29864	10.5%
4	27906	9.8%
6	18374	6.4%
7	17392	6.1%
5	17154	6.0%
8	13636	4.8%
9	12159	4.3%

Open Punctuation

Value	Count	Frequency (%)
(	11631	97.1%
[	245	2.0%
{	108	0.9%

Close Punctuation

Value	Count	Frequency (%)
)	11228	97.0%
]	353	3.0%

Space Separator

Value	Count	Frequency (%)
	503319	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	43158	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	281	100.0%

Math Symbol

Value	Count	Frequency (%)
+	19	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3348962	72.9%
Common	1248009	27.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	489814	14.6%
R	292293	8.7%
O	242069	7.2%
E	237516	7.1%
N	221315	6.6%
I	214583	6.4%
T	182808	5.5%
L	170531	5.1%
S	170365	5.1%
D	168891	5.0%
Other values (35)	958777	28.6%

Common

Value	Count	Frequency (%)
	503319	40.3%
,	267192	21.4%
.	96684	7.7%
1	65850	5.3%
2	49039	3.9%
-	43158	3.5%
3	34030	2.7%
0	29864	2.4%
4	27906	2.2%
/	22641	1.8%
Other values (19)	108326	8.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4595601	> 99.9%
None	1370	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	503319	11.0%
A	489814	10.7%
R	292293	6.4%
,	267192	5.8%
O	242069	5.3%
E	237516	5.2%
N	221315	4.8%
I	214583	4.7%
T	182808	4.0%
L	170531	3.7%
Other values (63)	1774161	38.6%

None

Value	Count	Frequency (%)
ß	1370	100.0%

Address2
Unsupported

Missing Rejected Unsupported

Missing	97057
Missing (%)	100.0%
Memory size	758.4 KiB

City
Text

Distinct	1289
Distinct (%)	1.3%
Missing	18
Missing (%)	< 0.1%
Memory size	6.2 MiB

Length

Max length	55
Median length	33
Mean length	17.389472
Min length	3

Characters and Unicode

Total characters	1687457
Distinct characters	69
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	183 ?
Unique (%)	0.2%

Sample

1st row	MAHARASHTRA
2nd row	GHATKOPAR (EAST), MUMBAI
3rd row	HYDERABAD, A.P.
4th row	BOMBAY ,MAHARASHTRA
5th row	NEW DELH I

Value	Count	Frequency (%)
mumbai	33601	18.3%
maharashtra	30554	16.6%
delhi	6755	3.7%
ahmedabad	5286	2.9%
hyderabad	4655	2.5%
pradesh	4537	2.5%
gujarat	4526	2.5%
new	4033	2.2%
mumbai,maharashtra	3649	2.0%
bangalore	3384	1.8%
Other values (983)	82681	45.0%

Most occurring characters

Value	Count	Frequency (%)
A	349473	20.7%
	144468	8.6%
M	141871	8.4%
R	132605	7.9%
H	123512	7.3%
I	78322	4.6%
D	70072	4.2%
B	68588	4.1%
T	67903	4.0%
U	67327	4.0%
Other values (59)	443316	26.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1422025	84.3%
Space Separator	144468	8.6%
Other Punctuation	100926	6.0%
Lowercase Letter	7158	0.4%
Close Punctuation	4510	0.3%
Open Punctuation	4510	0.3%
Dash Punctuation	2506	0.1%
Decimal Number	1354	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	349473	24.6%
M	141871	10.0%
R	132605	9.3%
H	123512	8.7%
I	78322	5.5%
D	70072	4.9%
B	68588	4.8%
T	67903	4.8%
U	67327	4.7%
E	61728	4.3%
Other values (16)	260624	18.3%

Lowercase Letter

Value	Count	Frequency (%)
e	719	10.0%
a	688	9.6%
l	595	8.3%
o	547	7.6%
n	547	7.6%
r	468	6.5%
t	468	6.5%
y	423	5.9%
i	344	4.8%
d	344	4.8%
Other values (11)	2015	28.2%

Decimal Number

Value	Count	Frequency (%)
1	560	41.4%
0	362	26.7%
8	130	9.6%
6	113	8.3%
5	99	7.3%
4	38	2.8%
2	27	2.0%
3	13	1.0%
7	6	0.4%
9	6	0.4%

Other Punctuation

Value	Count	Frequency (%)
,	60213	59.7%
.	32560	32.3%
/	7732	7.7%
&	209	0.2%
:	205	0.2%
?	7	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	3916	86.8%
]	594	13.2%

Open Punctuation

Value	Count	Frequency (%)
(	3916	86.8%
[	594	13.2%

Space Separator

Value	Count	Frequency (%)
	144468	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2506	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1429183	84.7%
Common	258274	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	349473	24.5%
M	141871	9.9%
R	132605	9.3%
H	123512	8.6%
I	78322	5.5%
D	70072	4.9%
B	68588	4.8%
T	67903	4.8%
U	67327	4.7%
E	61728	4.3%
Other values (37)	267782	18.7%

Common

Value	Count	Frequency (%)
	144468	55.9%
,	60213	23.3%
.	32560	12.6%
/	7732	3.0%
)	3916	1.5%
(	3916	1.5%
-	2506	1.0%
[	594	0.2%
]	594	0.2%
1	560	0.2%
Other values (12)	1215	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1687255	> 99.9%
None	202	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	349473	20.7%
	144468	8.6%
M	141871	8.4%
R	132605	7.9%
H	123512	7.3%
I	78322	4.6%
D	70072	4.2%
B	68588	4.1%
T	67903	4.0%
U	67327	4.0%
Other values (58)	443114	26.3%

None

Value	Count	Frequency (%)
ß	202	100.0%

ForeignCompany
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	6.7 MiB

Invoice_No
Unsupported

Rejected Unsupported

Missing	2
Missing (%)	< 0.1%
Memory size	5.0 MiB

CUSH
Text

Distinct	65
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.1 MiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	582342
Distinct characters	29
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	INNSA1
2nd row	INNSA1
3rd row	INHYD4
4th row	INNSA1
5th row	INHZA1

Value	Count	Frequency (%)
inbom4	27435	28.3%
innsa1	25697	26.5%
indel4	8104	8.3%
inhyd4	6399	6.6%
inrxlb	4712	4.9%
inmaa4	4148	4.3%
inblr4	3261	3.4%
inamd4	2869	3.0%
inmaa1	2269	2.3%
insnf6	1806	1.9%
Other values (55)	10357	10.7%

Most occurring characters

Value	Count	Frequency (%)
N	126119	21.7%
I	98786	17.0%
4	52963	9.1%
A	43218	7.4%
M	38243	6.6%
B	37595	6.5%
1	32474	5.6%
S	29369	5.0%
O	28519	4.9%
D	19000	3.3%
Other values (19)	76056	13.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	490220	84.2%
Decimal Number	92122	15.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	126119	25.7%
I	98786	20.2%
A	43218	8.8%
M	38243	7.8%
B	37595	7.7%
S	29369	6.0%
O	28519	5.8%
D	19000	3.9%
L	16551	3.4%
R	8705	1.8%
Other values (16)	44115	9.0%

Decimal Number

Value	Count	Frequency (%)
4	52963	57.5%
1	32474	35.3%
6	6685	7.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	490220	84.2%
Common	92122	15.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	126119	25.7%
I	98786	20.2%
A	43218	8.8%
M	38243	7.8%
B	37595	7.7%
S	29369	6.0%
O	28519	5.8%
D	19000	3.9%
L	16551	3.4%
R	8705	1.8%
Other values (16)	44115	9.0%

Common

Value	Count	Frequency (%)
4	52963	57.5%
1	32474	35.3%
6	6685	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	582342	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	126119	21.7%
I	98786	17.0%
4	52963	9.1%
A	43218	7.4%
M	38243	6.6%
B	37595	6.5%
1	32474	5.6%
S	29369	5.0%
O	28519	4.9%
D	19000	3.3%
Other values (19)	76056	13.1%

IEC_PIN
Unsupported

Missing Rejected Unsupported

Missing	2341
Missing (%)	2.4%
Memory size	3.6 MiB

Item_No
Real number (ℝ)

High correlation

Distinct	266
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.443307

Minimum	1
Maximum	281
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	758.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	7
95-th percentile	54
Maximum	281
Range	280
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	24.050746
Coefficient of variation (CV)	2.3029819
Kurtosis	30.915973
Mean	10.443307
Median Absolute Deviation (MAD)	1
Skewness	4.8766405
Sum	1013596
Variance	578.43839
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	40011	41.2%
2	12517	12.9%
3	7226	7.4%
4	4984	5.1%
5	3599	3.7%
6	2780	2.9%
7	2173	2.2%
8	1796	1.9%
9	1520	1.6%
10	1302	1.3%
Other values (256)	19149	19.7%

Value	Count	Frequency (%)
1	40011	41.2%
2	12517	12.9%
3	7226	7.4%
4	4984	5.1%
5	3599	3.7%
6	2780	2.9%
7	2173	2.2%
8	1796	1.9%
9	1520	1.6%
10	1302	1.3%

Value	Count	Frequency (%)
281	2	< 0.1%
280	2	< 0.1%
279	2	< 0.1%
278	2	< 0.1%
277	2	< 0.1%
276	2	< 0.1%
272	3	< 0.1%
270	3	< 0.1%
266	3	< 0.1%
263	3	< 0.1%

Item_Rate_INR
Real number (ℝ)

High correlation Skewed Zeros

Distinct	64777
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38399.905

Minimum	-3890.9
Maximum	1.3233761 × 10⁸
Zeros	11676
Zeros (%)	12.0%
Negative	6
Negative (%)	< 0.1%
Memory size	758.4 KiB

Quantile statistics

Minimum	-3890.9
5-th percentile	0
Q1	24
median	145.0955
Q3	1097.4125
95-th percentile	55296.03
Maximum	1.3233761 × 10⁸
Range	1.323415 × 10⁸
Interquartile range (IQR)	1073.4125

Descriptive statistics

Standard deviation	798886.86
Coefficient of variation (CV)	20.804397
Kurtosis	13543.916
Mean	38399.905
Median Absolute Deviation (MAD)	145.0955
Skewness	99.114969
Sum	3.7269796 × 10⁹
Variance	6.3822022 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11676	12.0%
1000	459	0.5%
333.3333333	215	0.2%
132.7	210	0.2%
500	207	0.2%
66.35	184	0.2%
66.6	162	0.2%
133.2	159	0.2%
100	138	0.1%
250	115	0.1%
Other values (64767)	83532	86.1%

Value	Count	Frequency (%)
-3890.9	1	< 0.1%
-3890.8	3	< 0.1%
-2348.4	1	< 0.1%
-778.18	1	< 0.1%
0	11676	12.0%
7 × 10^-6	1	< 0.1%
8 × 10^-6	1	< 0.1%
8.82 × 10^-6	1	< 0.1%
9.62 × 10^-6	2	< 0.1%
9.8 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
132337611.1	1	< 0.1%
112631170	1	< 0.1%
83127705	1	< 0.1%
56307570	1	< 0.1%
37538380	1	< 0.1%
33251080	1	< 0.1%
33004333.33	2	< 0.1%
32977521	1	< 0.1%
31842500	1	< 0.1%
24841250	1	< 0.1%

Interactions

Correlations

	4Digit	BillNO	Currency	FOB INR	HSCode	IEC	Item_No	Item_Rate_INR	Item_Rate_INV	Quantity	Total_Amount_INV_FC	Unit
4Digit	1.000	0.018	0.085	-0.122	0.899	0.029	0.385	-0.340	-0.378	0.222	-0.128	0.448
BillNO	0.018	1.000	0.032	0.091	0.011	-0.011	-0.020	0.073	0.005	0.014	0.025	0.131
Currency	0.085	0.032	1.000	0.000	0.085	0.060	0.033	0.000	0.076	0.000	0.034	0.095
FOB INR	-0.122	0.091	0.000	1.000	-0.121	0.060	-0.529	0.435	0.325	0.652	0.855	0.034
HSCode	0.899	0.011	0.085	-0.121	1.000	0.045	0.367	-0.311	-0.347	0.195	-0.128	0.448
IEC	0.029	-0.011	0.060	0.060	0.045	1.000	-0.031	0.108	0.091	-0.004	0.035	0.139
Item_No	0.385	-0.020	0.033	-0.529	0.367	-0.031	1.000	-0.237	-0.240	-0.295	-0.508	0.086
Item_Rate_INR	-0.340	0.073	0.000	0.435	-0.311	0.108	-0.237	1.000	0.795	-0.255	0.272	0.023
Item_Rate_INV	-0.378	0.005	0.076	0.325	-0.347	0.091	-0.240	0.795	1.000	-0.249	0.446	0.027
Quantity	0.222	0.014	0.000	0.652	0.195	-0.004	-0.295	-0.255	-0.249	1.000	0.682	0.019
Total_Amount_INV_FC	-0.128	0.025	0.034	0.855	-0.128	0.035	-0.508	0.272	0.446	0.682	1.000	0.000
Unit	0.448	0.131	0.095	0.034	0.448	0.139	0.086	0.023	0.027	0.019	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	BillNO	4Digit	Date	HSCode	Product	Quantity	Unit	Item_Rate_INV	Currency	Total_Amount_INV_FC	FOB INR	ForeignPort	ForeignCountry	IndianPort	IEC	IndianCompany	Address1	Address2	City	ForeignCompany	Invoice_No	CUSH	IEC_PIN	Item_No	Item_Rate_INR
0	8001439	2915	2016-06-01	29157090	ETHYLENE GLYCOL DISTERATE (Assay 98% minimum) (EGDS)	2400.000	KGS	2.855	USD	6852.000000	435999.12	Chittagong	BANGLADESH	Nhava Sheva Sea	388162040	GALAXY SURFACTANTS LTD.,	C-49/2,TTC INDUSTRIAL AREAPAWNE, NAVI MUMBAI.	NaN	MAHARASHTRA	UNILEVER BANGLADESH LTD.	80206964	INNSA1	400703	1	181.666300
1	8021997	2915	2016-06-01	29159090	COSMOSIL IM	2100.000	KGS	5.750	USD	12075.000000	814446.25	Colombo	SRI LANKA	Nhava Sheva Sea	396073964	DADIA CHEMICAL INDUSTRIES	201, SHIVAM , 3RD FLOOR, SATYAM SHOPPING CENTRE,M.G. ROAD	NaN	GHATKOPAR (EAST), MUMBAI	HARUMI HOLDINGS (PVT) LTD,	DCI/EXP-03/16-17	INNSA1	PIN-400077	1	387.831548
2	8019786	2916	2016-06-01	29163190	MEBEVERINE HCL BP	750.000	KGS	85.000	USD	63750.000000	4134001.50	Riyadh	SAUDI ARABIA	Hyderabad Air Cargo	996000836	RA CHEM PHARMA LIMITED	#.6-3-1239/2, AMAR HOUSE, 4TH FLOORRAJBHAWAN ROAD, SOMAJIGUDA,	NaN	HYDERABAD, A.P.	MEDICAL & COSMETIC PRODUCTS CO.LTD	EXP/A106/16-17	INHYD4	500082	1	5512.002000
3	8006507	2916	2016-06-01	29163990	WE INTEND TO CLAIM REWARDS UNDER MERCHANDISE EXPORTS FROM INDIA SCHEME (MEIS)	0.001	NOS	0.001	USD	0.000001	0.00	Veracruz	MEXICO	Nhava Sheva Sea	388170247	CHEMSPEC CHEMICALS PVT LTD	9 WALLACE ST FORT	NaN	BOMBAY ,MAHARASHTRA	COSBEL S.A. DE C.V.	CSEXP/2016-17/143	INNSA1	400001	2	0.000000
4	8015210	2917	2016-06-01	29171990	"Payflex-M-80" Di Octyl Maleate Ester, C	44000.000	KGS	1.180	USD	51920.000000	34.09	Jeddah	SAUDI ARABIA	Hazira	511004346	PAYAL PETROCHEM PRIVATE LIMITED	E-24, NETAJI SUBHASH MARGDARYAGANJ	NaN	NEW DELH I	S. S. C. I.. C. L.	PM/EXP/048	INHZA1	NaN	1	0.000000
5	8017527	2917	2016-06-01	29171990	LABORATORY CHEMICAL - SODIUM SUCCINATE	5600.000	KGS	95.000	USD	532000.000000	705964.00	Port Kelang	MALAYSIA	Nhava Sheva Sea	388045485	S. D. FINE CHEM LTD.	315-317, T. V. INDUSTRIAL ESTATE,248, WORLI ROAD,	NaN	MUMBAI	BIOCON SDN BHD	COR/9126	INNSA1	400025	1	126.065000
6	8015831	2917	2016-06-01	29173910	"Payflex-P-400" Di Butyl Phthalate (DBP)	66000.000	KGS	0.990	USD	65340.000000	42.20	Dammam	SAUDI ARABIA	Hazira	511004346	PAYAL PETROCHEM PRIVATE LIMITED	E-24, NETAJI SUBHASH MARGDARYAGANJ	NaN	NEW DELH I	I. D. C.	PM/EXP/049	INHZA1	NaN	1	0.000000
7	8008259	2917	2016-06-01	29173920	DI OCTYL PHTHALATE (DOP) (AS PER INV.)	20000.000	KGS	1.180	USD	23600.000000	1432231.10	Houston	UNITED STATES	Nhava Sheva Sea	596059035	KLJ PLASTICIZERS LIMITED	KLJ HOUSE 63 RAMA MARGNAJAFGARH ROAD	NaN	NEW DELHI	I.C.I.	KP/16-17/114	INNSA1	110015	1	71.611555
8	8012852	2915	2016-06-01	29159090	2-ETHYL HEXANOYL CHLORIDE MIN.99.00% "(OTHER SATRTD ACYLC MNOCRBIXYLC ACDS ETCAND THR DRVTVS) WE INTEND TO CLAIM REWA	15200.000	KGS	2.400	USD	36480.000000	2403197.00	Rotterdam	NETHERLANDS	Nhava Sheva Sea	3401001213	SHIVA PHARMACHEM LTD,	8TH FLOOR, ABS TOWERS OLD PADRA RD	NaN	BARODA	SHIVA PHARMACHEM AG	9160140036	INNSA1	390007	1	158.105066
9	8005941	2917	2016-06-01	29173940	CHEMICAL: DIMETHYL PHTHALATE (DMP) IN IS	26000.000	KGS	1.220	USD	31720.000000	1794000.00	Gothenburg	UNITED STATES	Mundra Sea	389029971	AARTI INDUSTRIES LIMITED	UDYOG KSHETRA,2ND FLOOR,MULUNDGOREGAON LINK ROAD,MULUND (W),	NaN	MUMBAI / MAHARASHTRA	UNITED INITIATORS AB	EX/1049/16-17	INMUN1	400080	1	0.000000

	BillNO	4Digit	Date	HSCode	Product	Quantity	Unit	Item_Rate_INV	Currency	Total_Amount_INV_FC	FOB INR	ForeignPort	ForeignCountry	IndianPort	IEC	IndianCompany	Address1	Address2	City	ForeignCompany	Invoice_No	CUSH	IEC_PIN	Item_No	Item_Rate_INR
97047	8603261	3004	2016-06-30	30049039	FEXOFENADINE HYDROCHLORIDE TABLETS 180MG(PHARMACIST FORMULA FEXOFENADINE 180MGTABLETS) 3X10S	5124.0	PAC	2.78	AUD	14244.72	694430.03	Sydney	AUSTRALIA	Bangalore	791000770	MEDREICH LIMITED	MEDREICH HOUSE, NO12/8,SARASWATHI AMMAL STREET, MARUTHI	NaN	SEVA NAGAR, BANGALORE, KARNATAKA	M/S. MEDREICH AUSTRALIA	8150015579	INWFD6	560033	4	135.524986
97048	8603319	3004	2016-06-30	30045039	IRON+FOLIC ACID+VITAMIN B12 SYRUP (BIOFERON LIQUID) 200ML	8556.0	PAC	0.65	USD	5561.40	368998.89	Le Havre	FRANCE	Bangalore	791000770	MEDREICH LIMITED	MEDREICH HOUSE, NO12/8,SARASWATHI AMMAL STREET, MARUTHI	NaN	SEVA NAGAR, BANGALORE, KARNATAKA	M/S. SANOFI AVENTIS	8150015557	INWFD6	560033	1	43.127500
97049	8603351	3004	2016-06-30	30049099	TIMOLOL EYE DROPS BP 0.5% W/V (TIMOL 0.5%) 10ML	8550.0	PAC	0.21	USD	1795.50	119131.43	Le Havre	FRANCE	Bangalore	791000770	MEDREICH LIMITED	MEDREICH HOUSE, NO12/8,SARASWATHI AMMAL STREET, MARUTHI	NaN	SEVA NAGAR, BANGALORE, KARNATAKA	M/S. SANOFI AVENTIS	8150015578	INWFD6	560033	2	13.933501
97050	8603357	3004	2016-06-30	30041090	MARINA-1000 - FISH LIPID OIL CAPSULES 1000MG (X2X15'S) (AS PER INVOICE) MFD BY STRIDES SHASUN LTD.ORAL DOSAGE FORMS	51665.0	NOS	0.70	USD	36165.50	2321287.93	Apapa	NIGERIA	Bangalore	390012441	STRIDES SHASUN LIMITED	206, DEVAVRATA,SECTOR 17, VASHI,	NaN	NAVI MUMBAI, MAHARASHTRA.	M/S.WORLD WIDE COMMERCIAL VENTURES	4139007618	INWFD6	400705	1	44.929603
97051	8603361	3004	2016-06-30	30041090	ERYTHROMYCIN TABLETS BP 250MG (X2X14'S)(AS PER INVOICE) MFD BY STRIDES SHASUN LTD. ORAL DOSAGE FORMS	102932.0	NOS	0.55	GBP	56612.60	4663798.94	Felixstowe	UNITED KINGDOM	Bangalore	390012441	STRIDES SHASUN LIMITED	206, DEVAVRATA,SECTOR 17, VASHI,	NaN	NAVI MUMBAI, MAHARASHTRA.	M/S.CO-PHARMA LIMITED,	4139007622	INWFD6	400705	1	45.309514
97052	8603361	3004	2016-06-30	30041090	INDAPAMIDE TABLETS 2.5MG (X4X7'S) (AS PER INVOICE) MFD BY STRIDES SHASUN LTD. ORAL DOSAGE FORMS	126794.0	NOS	0.38	GBP	48181.72	3969255.86	Felixstowe	UNITED KINGDOM	Bangalore	390012441	STRIDES SHASUN LIMITED	206, DEVAVRATA,SECTOR 17, VASHI,	NaN	NAVI MUMBAI, MAHARASHTRA.	M/S.CO-PHARMA LIMITED,	4139007622	INWFD6	400705	2	31.304761
97053	8603363	3004	2016-06-30	30041090	BUSPIRONE HYDROCHLORIDE TABLETS 5MG (3X10'S) (AS PER INVOICE) MFD BY STRIDES SHASUN LTD. ORAL DOSAGE FORMS	10664.0	NOS	1.50	GBP	15996.00	1363018.90	Felixstowe	UNITED KINGDOM	Bangalore	390012441	STRIDES SHASUN LIMITED	206, DEVAVRATA,SECTOR 17, VASHI,	NaN	NAVI MUMBAI, MAHARASHTRA.	M/S.CO-PHARMA LIMITED,	KRSG-301	INWFD6	400705	3	127.814976
97054	8603447	3004	2016-06-30	30042019	CEFOTAXIME SODIUM FOR INJECTION 1G (ZOTAX) 1+1S	21600.0	PAC	0.56	USD	12096.00	802569.60	Aden	YEMEN DEMOCRATIC	Bangalore	791000770	MEDREICH LIMITED	MEDREICH HOUSE, NO12/8,SARASWATHI AMMAL STREET, MARUTHI	NaN	SEVA NAGAR, BANGALORE, KARNATAKA	M/S. AL JABAR PHARMA FOR DRUGS & ME	8150015502	INWFD6	560033	1	37.156000
97055	8603452	3004	2016-06-30	30041090	PREDSONE - PREDNISONE TABLETS 1MG (X100TABS) (AS PER INVOICE) MFD BY STRIDES SHASUN LTD.ORAL DOSAGE FORMS	19420.0	NOS	0.93	AUD	18060.60	869483.90	Sydney	AUSTRALIA	Bangalore	390012441	STRIDES SHASUN LIMITED	206, DEVAVRATA,SECTOR 17, VASHI,	NaN	NAVI MUMBAI, MAHARASHTRA.	M/S.ASPEN PHARMACARE PTY LTD,	4139007609	INWFD6	400705	2	44.772600
97056	8603452	3004	2016-06-30	30041090	PERIACTIN - CYPROHEPTADINE TABLETS 4MG (X10X10'S) (AS PER INVOICE) MFD BY STRIDES SHASUN LTD. ORAL DOSAGE FORMS	11587.0	NOS	2.73	AUD	31632.51	1522870.39	Sydney	AUSTRALIA	Bangalore	390012441	STRIDES SHASUN LIMITED	206, DEVAVRATA,SECTOR 17, VASHI,	NaN	NAVI MUMBAI, MAHARASHTRA.	M/S.ASPEN PHARMACARE PTY LTD,	4139007609	INWFD6	400705	5	131.429222

Duplicate rows

Most frequently occurring

	BillNO	4Digit	Date	HSCode	Product	Quantity	Unit	Item_Rate_INV	Currency	Total_Amount_INV_FC	FOB INR	ForeignPort	ForeignCountry	IndianPort	IEC	IndianCompany	Address1	City	CUSH	Item_No	Item_Rate_INR	# duplicates
0	8011036	2929	2016-06-01	29291020	TOLUENE DI ISOCYANATE 80:20	20.0	MTS	1990.000	USD	39800.0	26.05	Riyadh	SAUDI ARABIA	Hazira	888000685	GUJARAT NARMADA VALLEY FERTILIZERS & CHEMICALS LTD	P O NARMADANAGAR	DIST BHARUCH ,GUJRAT	INHZA1	1	0.00000	7
21	8310294	2929	2016-06-16	29291020	TOLUENE DIISOCYANATE 80:20	20.0	MTS	2110.000	USD	42200.0	2759904.00	Apapa	NIGERIA	Ankleshwar	3406000321	PALVI POWER TECH SALES P LTD	228 ARPAN COMPLEX NR.HANUMAN TEMPLENIZAMPURA	BARODA (GJ)	INAKV6	1	137995.20000	6
1	8037103	2929	2016-06-02	29291020	TOLUENE DI ISOCYANATE 80/20	20.0	MTS	1953.000	USD	39060.0	25.48	Mombasa	KENYA	Hazira	888000685	GUJARAT NARMADA VALLEY FERTILIZERS & CHEMICALS LTD	P O NARMADANAGAR	DIST BHARUCH ,GUJRAT	INHZA1	1	0.00000	5
25	8380247	2929	2016-06-20	29291020	TOLUENE DIISOCYANATE 80:20	20.0	MTS	2260.000	USD	45200.0	29.81	Alexandra(Egypt)	EGYPT	Hazira	3406000321	PALVI POWER TECH SALES P LTD	228 ARPAN COMPLEX NR.HANUMAN TEMPLENIZAMPURA	BARODA (GJ)	INHZA1	1	0.00000	5
29	8412599	2929	2016-06-22	29291020	TOLUENE DIISOCYANATE 80:20	20.0	MTS	2240.000	USD	44800.0	29.62	Jebel Ali	UNITED ARAB EMIRATES	Hazira	3406000321	PALVI POWER TECH SALES P LTD	228 ARPAN COMPLEX NR.HANUMAN TEMPLENIZAMPURA	BARODA (GJ)	INHZA1	1	0.00000	5
30	8428293	2929	2016-06-22	29291020	TOLUENE DI ISOCYANATE (80/20)	20.0	MTS	1660.000	USD	33200.0	21.64	Jebel Ali	UNITED ARAB EMIRATES	Hazira	804007705	DASALDHAN CHEMICALS PVT. LIMITED	B/4, VIJAY TOWER, OPP: ABADDAIRY, KANKARIA,	AHMEDABAD	INHZA1	1	0.00000	5
36	8599679	2929	2016-06-30	29291020	TOLUENE DIISOCYANATE 80:20	20.0	MTS	2260.000	USD	45200.0	29.83	Alexandra(Egypt)	EGYPT	Hazira	3406000321	PALVI POWER TECH SALES P LTD	228 ARPAN COMPLEX NR.HANUMAN TEMPLENIZAMPURA	BARODA (GJ)	INHZA1	1	0.00000	5
2	8037870	2929	2016-06-02	29291020	TOLUENE DI-ISOCYNATE (TDI 80/20)	20000.0	KGS	2.150	USD	43000.0	27.88	Apapa	NIGERIA	Hazira	3402001152	PRAKASH CHEMICALS INTERNATIONAL PVT. LIMITED	INDUCHACHA HOUSE OPP-CHHANI OCTROINAKA	BARODA	INHZA1	1	0.00000	4
22	8337188	2921	2016-06-17	29212910	HEXAMINE (UN-STABILIZED)	18.0	MTS	1207.000	USD	21726.0	1281450.73	Houston	UNITED STATES	Ankleshwar	288000994	KANORIA CHEMICALS & INDUSTRIES LTD	PARK PLAZA71 PARK STREET	CALCUTTA, WEST BENGAL	INAKV6	1	71191.70722	4
23	8339169	2929	2016-06-17	29291020	TOLUENE DI-ISOCYNATE (TDI 80/20)	20000.0	KGS	2.185	USD	43700.0	28.63	Mombasa	KENYA	Hazira	3402001152	PRAKASH CHEMICALS INTERNATIONAL PVT. LIMITED	INDUCHACHA HOUSE OPP-CHHANI OCTROINAKA	BARODA	INHZA1	1	0.00000	4

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Math Symbol

Open Punctuation

Close Punctuation

Modifier Symbol

Space Separator

Dash Punctuation

Connector Punctuation

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block